CREATE EXTERNAL TABLE jms_dm.dm_dev_center_operate_summary_dt
(
    network_code          string comment '到件站点code',
    network_name          string comment '到件站点name',
    out_way_num           int comment '出港量',
    out_pack_way_num      int comment '出港卸车包内票量',
    out_zddev_way_num     int comment '出港自动建包量',
    out_rgdev_way_num     int comment '出港人工建包量',
    same_way_num          int comment '同城量',
    same_pack_way_num     int comment '同城卸车包内票量',
    same_zddev_way_num    int comment '同城自动建包量',
    same_rgdev_way_num    int comment '同城人工建包量',
    transfer_way_num      int comment '中转量',
    transfer_pack_way_num int comment '中转卸车包内票量',
    in_way_num            int comment '进港量',
    in_pack_way_num       int comment '进港卸车包内票量',
    in_tear_pack_num      int comment '进港拆包量',
    in_tear_way_num       int comment '进港拆包包内票量',
    in_build_pack_num     int comment '进港建包量',
    in_way_total          int comment '归属出港量',
    out_way_total         int comment '归属出港量',
    date_time             string comment '日期'
) comment '中转件量分析汇总'
    partitioned by (dt string comment 't-2')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_dev_center_operate_summary_dt'
;
